CREATE DATABASE PharmacyOnline
use PharmacyOnline
CREATE TABLE tblUsers(
Users_Id INT NOT NULL PRIMARY KEY,
Users_Name NVARCHAR(30) NOT NULL,
Users_Password NVARCHAR(20) NOT NULL
)
GO 
CREATE TABLE tblProducts(
P_ID INT NOT NULL PRIMARY KEY,
P_Name NVARCHAR(50) NOT NULL,
P_type INT NOT NULL,
P_Infomation NVARCHAR(500) NOT NULL,
P_Image NVARCHAR(300),
)
